Parameter reminder that causes Oracle performance jitter

Preface unwittingly, the story of me and the data center in the technology life series has come to the fourth issue. Little y to see you again! When you see the following wavy tps curve in the business system stress test, how do you do it? What Xiao y (Zhongyi Technology) wants to share with you today is such a business system pressure.

2022-06-01 Database 我要分享

Technology Life Series the Story of me and the data Center (issue 4)-Parameter reminders that lead to Oracle performance jitter

Preface unwittingly, the story of me and the data center in the technology life series has come to the fourth issue. Little y to see you again! When you see the following wavy tps curve in the business system stress test, how do you do it? What Xiao y (Zhongyi Technology) wants to share with you today is such a business system pressure.

2022-06-01 Database 我要分享

Systemstate Dump Analysis of Classical cases (part I)

In the preface, we invite Lao K, another Oracle expert from Zhongyi Technology, to share with you the classic cases of systemstate dump analysis. After that, we will have more technical experts to bring more sincerity to share. Lao K as a database project that has struggled in the data center for a long time.

2022-06-01 Database 我要分享

Show engine innodb status interpretation

Show engine innodb status interpretation Note: the following is based on the personal understanding of the innodb status section of "High performance mysql third Edition" and "mysql Technology Insider innodb Storage engine". If there is any error,

2022-06-01 Database 我要分享

How to parse LINUX netstat connection state and perform TCP state transition

This article is about how to analyze the LINUX netstat connection state and TCP state transition, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article, without saying much, let's take a look at it with the editor. L

2022-06-01 Servers 我要分享

How to implement await and signal waiting / Notification Mechanism of Condition

Editor to share with you how to implement Condition's await and signal wait / notify mechanism. I hope you will get something after reading this article. Let's discuss it together. About 1.Condition any java object is natural

2022-06-02 Development 我要分享

What are the problems and solutions of MySQL in concurrent scenarios

This article shows you the problems and solutions of MySQL in concurrent scenarios. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. 1. The background is raised under the condition of multi-user concurrency for the database system.

2022-05-31 Database 我要分享

What are the parameters wait_timeout and interactive_timeout in MySQL and the implementation method of idle timeout

This article introduces the relevant knowledge of "what are the parameters wait_timeout and interactive_timeout in MySQL and the implementation of idle timeout". In the operation of practical cases, many people will encounter such a dilemma, and then let small

2022-05-31 Database 我要分享

Why does Waiting for table metadata lock appear in MySQL?

Editor, I would like to share with you why there is Waiting for table metadata lock in MySQL. I believe most people don't know much about it, so share this article for your reference. I hope you will learn a lot after reading this article.

2022-05-31 Database 我要分享

Performance Diagnosis with AWR

Performance Diagnosis with Automatic Workload Repository (AWR) (Doc ID 1674086.1) In This Document1 P

2022-06-01 Database 我要分享

Analyze the problems and solutions under the concurrency of MySQL

1. Background for the database system, it has always been the goal of the database system to improve the concurrency under the condition of multi-user concurrency while ensuring the consistency of the data. not only to meet the needs of a large number of concurrent access, but also to ensure the security of data under this condition, in order to meet this goal, most databases use locks

2022-06-01 Database 我要分享

Matters needing attention when using wait () method and notify () method in Java

This article mainly talks about "precautions when using wait () method and notify () method in Java". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn the wait () method in Java.

2022-06-02 Internet Technology 我要分享

SQL*Net Wait Events

What is a Wait Event? During the normal functioning of a database, an Oracle process will occasional

2022-06-01 Database 我要分享

Process scheduling BUG that needs to be paid attention to when running ORACLE on a small computer

The name "Xiao y" is a pseudonym that the author thought of temporarily. In fact, it doesn't have any special meaning. Let's just use it to represent a group of unknown IT people who dedicate their youth to various data centers. What Xiao y wants to share with you today is the process of analyzing difficult and complicated diseases. If everyone

2022-06-01 Database 我要分享

Why SQL Server instances are under pressure

Why are SQL Server instances under pressure to translate from: https://www.simple-talk.com/sql/database-administration/why-is-that-sql-serv

2022-06-01 Database 我要分享

Oracle local write wait wait event

Note 1:TypicallyDBWR has to free up some buffers when you want to read something from the disk.Durin

2022-06-01 Database 我要分享

Percona monitors what several graphics of mysql look like.

This article shows you what the percona monitoring mysql graphics are like, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. Several graphical explanations of percona monitoring mysql recently

2022-05-31 Database 我要分享

Optimization of waiting event LOG FILE SYNC (awr) for oracle

Log file sycn is one of the most common waiting events in ORACLE. In general, the waiting time of log file sycn is very short 1-5ms, so there will be no problem, but when something goes wrong, it is often difficult to solve. When will log f be generated?

2022-06-01 Database 我要分享

Troubleshooting ideas for slow operation of the system, CPU 100%, and excessive Full GC times

Source: students who have dealt with online problems with http://t.cn/EI9JdBu will basically encounter problems such as sudden slow operation of the system, 100% CPU, and too many Full GC times. Of course, the intuitive phenomenon that these problems eventually lead to is that the system runs slowly.

2022-06-02 Servers 我要分享

What are the common waiting events in ORACLE

This article mainly introduces "what are the common waiting events in ORACLE". In daily operation, I believe many people have doubts about the common waiting events in ORACLE. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope to answer "ORACLE often" to you.

2022-05-31 Database 我要分享